Pandas Profiling Report

Dataset statistics

Number of variables	31
Number of observations	40060
Missing cells	464
Missing cells (%)	< 0.1%
Duplicate rows	2325
Duplicate rows (%)	5.8%
Total size in memory	9.5 MiB
Average record size in memory	248.0 B

Variable types

Categorical	19
Numeric	12

Alerts

Dataset has 2325 (5.8%) duplicate rows	Duplicates
`Country` has a high cardinality: 125 distinct values	High cardinality
`Agent` has a high cardinality: 186 distinct values	High cardinality
`Company` has a high cardinality: 236 distinct values	High cardinality
`ReservationStatusDate` has a high cardinality: 913 distinct values	High cardinality
`LeadTime` is highly overall correlated with `StaysInWeekNights`	High correlation
`ArrivalDateWeekNumber` is highly overall correlated with `ArrivalDateMonth`	High correlation
`StaysInWeekendNights` is highly overall correlated with `StaysInWeekNights`	High correlation
`StaysInWeekNights` is highly overall correlated with `LeadTime` and 1 other fields	High correlation
`IsCanceled` is highly overall correlated with `ReservationStatus`	High correlation
`ArrivalDateMonth` is highly overall correlated with `ArrivalDateWeekNumber`	High correlation
`MarketSegment` is highly overall correlated with `DistributionChannel`	High correlation
`DistributionChannel` is highly overall correlated with `MarketSegment`	High correlation
`ReservedRoomType` is highly overall correlated with `AssignedRoomType`	High correlation
`AssignedRoomType` is highly overall correlated with `ReservedRoomType`	High correlation
`ReservationStatus` is highly overall correlated with `IsCanceled`	High correlation
`Children` is highly imbalanced (77.7%)	Imbalance
`Babies` is highly imbalanced (93.3%)	Imbalance
`Meal` is highly imbalanced (54.6%)	Imbalance
`Country` is highly imbalanced (56.6%)	Imbalance
`IsRepeatedGuest` is highly imbalanced (73.8%)	Imbalance
`DepositType` is highly imbalanced (81.8%)	Imbalance
`Company` is highly imbalanced (89.4%)	Imbalance
`RequiredCarParkingSpaces` is highly imbalanced (74.9%)	Imbalance
`Country` has 464 (1.2%) missing values	Missing
`Adults` is highly skewed (γ1 = 31.61075868)	Skewed
`LeadTime` has 3236 (8.1%) zeros	Zeros
`StaysInWeekendNights` has 14181 (35.4%) zeros	Zeros
`StaysInWeekNights` has 2682 (6.7%) zeros	Zeros
`PreviousCancellations` has 38965 (97.3%) zeros	Zeros
`PreviousBookingsNotCanceled` has 38028 (94.9%) zeros	Zeros
`BookingChanges` has 32252 (80.5%) zeros	Zeros
`DaysInWaitingList` has 39805 (99.4%) zeros	Zeros
`ADR` has 751 (1.9%) zeros	Zeros
`TotalOfSpecialRequests` has 22361 (55.8%) zeros	Zeros

Reproduction

Analysis started	2023-11-24 17:45:29.492562
Analysis finished	2023-11-24 17:45:42.476873
Duration	12.98 seconds
Software version	ydata-profiling v0.0.dev0
Download configuration	config.json

IsCanceled
Categorical

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	313.1 KiB

0	28938
1	11122

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	40060
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0
2nd row	0
3rd row	0
4th row	0
5th row	0

Common Values

Value	Count	Frequency (%)
0	28938	72.2%
1	11122	27.8%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
0	28938	72.2%
1	11122	27.8%

Most occurring characters

Value	Count	Frequency (%)
0	28938	72.2%
1	11122	27.8%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	40060	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	28938	72.2%
1	11122	27.8%

Most occurring scripts

Value	Count	Frequency (%)
Common	40060	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	28938	72.2%
1	11122	27.8%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	40060	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	28938	72.2%
1	11122	27.8%

LeadTime
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	412
Distinct (%)	1.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	92.675686

Minimum	0
Maximum	737
Zeros	3236
Zeros (%)	8.1%
Negative	0
Negative (%)	0.0%
Memory size	313.1 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	10
median	57
Q3	155
95-th percentile	287
Maximum	737
Range	737
Interquartile range (IQR)	145

Descriptive statistics

Standard deviation	97.285315
Coefficient of variation (CV)	1.0497394
Kurtosis	0.71548823
Mean	92.675686
Median Absolute Deviation (MAD)	54
Skewness	1.1327159
Sum	3712588
Variance	9464.4326
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	3236	8.1%
1	1595	4.0%
2	939	2.3%
3	794	2.0%
4	663	1.7%
5	600	1.5%
7	573	1.4%
6	538	1.3%
10	391	1.0%
8	388	1.0%
Other values (402)	30343	75.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	3236	8.1%
1	1595	4.0%
2	939	2.3%
3	794	2.0%
4	663	1.7%
5	600	1.5%
6	538	1.3%
7	573	1.4%
8	388	1.0%
9	368	0.9%

Value	Count	Frequency (%)
737	1	< 0.1%
709	1	< 0.1%
542	23	0.1%
532	1	< 0.1%
471	6	< 0.1%
468	47	0.1%
462	20	< 0.1%
460	3	< 0.1%
454	1	< 0.1%
450	1	< 0.1%

ArrivalDateYear
Categorical

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	313.1 KiB

2016	18567
2017	13179
2015	8314

Length

Max length	4
Median length	4
Mean length	4
Min length	4

Characters and Unicode

Total characters	160240
Distinct characters	6
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	2015
2nd row	2015
3rd row	2015
4th row	2015
5th row	2015

Common Values

Value	Count	Frequency (%)
2016	18567	46.3%
2017	13179	32.9%
2015	8314	20.8%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
2016	18567	46.3%
2017	13179	32.9%
2015	8314	20.8%

Most occurring characters

Value	Count	Frequency (%)
2	40060	25.0%
0	40060	25.0%
1	40060	25.0%
6	18567	11.6%
7	13179	8.2%
5	8314	5.2%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	160240	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
2	40060	25.0%
0	40060	25.0%
1	40060	25.0%
6	18567	11.6%
7	13179	8.2%
5	8314	5.2%

Most occurring scripts

Value	Count	Frequency (%)
Common	160240	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
2	40060	25.0%
0	40060	25.0%
1	40060	25.0%
6	18567	11.6%
7	13179	8.2%
5	8314	5.2%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	160240	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
2	40060	25.0%
0	40060	25.0%
1	40060	25.0%
6	18567	11.6%
7	13179	8.2%
5	8314	5.2%

ArrivalDateMonth
Categorical

Distinct	12
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	313.1 KiB

August	4894
July	4573
April	3609
May	3559
October	3555
Other values (7)	19870

Length

Max length	9
Median length	7
Mean length	5.9648028
Min length	3

Characters and Unicode

Total characters	238950
Distinct characters	26
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	July
2nd row	July
3rd row	July
4th row	July
5th row	July

Common Values

Value	Count	Frequency (%)
August	4894	12.2%
July	4573	11.4%
April	3609	9.0%
May	3559	8.9%
October	3555	8.9%
March	3336	8.3%
September	3108	7.8%
February	3103	7.7%
June	3045	7.6%
December	2648	6.6%
Other values (2)	4630	11.6%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
august	4894	12.2%
july	4573	11.4%
april	3609	9.0%
may	3559	8.9%
october	3555	8.9%
march	3336	8.3%
september	3108	7.8%
february	3103	7.7%
june	3045	7.6%
december	2648	6.6%
Other values (2)	4630	11.6%

Most occurring characters

Value	Count	Frequency (%)
e	31845	13.3%
r	27092	11.3%
u	22702	9.5%
b	14851	6.2%
a	14384	6.0%
y	13428	5.6%
t	11557	4.8%
J	9811	4.1%
c	9539	4.0%
A	8503	3.6%
Other values (16)	75238	31.5%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	198890	83.2%
Uppercase Letter	40060	16.8%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	31845	16.0%
r	27092	13.6%
u	22702	11.4%
b	14851	7.5%
a	14384	7.2%
y	13428	6.8%
t	11557	5.8%
c	9539	4.8%
m	8193	4.1%
l	8182	4.1%
Other values (8)	37117	18.7%

Uppercase Letter

Value	Count	Frequency (%)
J	9811	24.5%
A	8503	21.2%
M	6895	17.2%
O	3555	8.9%
S	3108	7.8%
F	3103	7.7%
D	2648	6.6%
N	2437	6.1%

Most occurring scripts

Value	Count	Frequency (%)
Latin	238950	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	31845	13.3%
r	27092	11.3%
u	22702	9.5%
b	14851	6.2%
a	14384	6.0%
y	13428	5.6%
t	11557	4.8%
J	9811	4.1%
c	9539	4.0%
A	8503	3.6%
Other values (16)	75238	31.5%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	238950	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
e	31845	13.3%
r	27092	11.3%
u	22702	9.5%
b	14851	6.2%
a	14384	6.0%
y	13428	5.6%
t	11557	4.8%
J	9811	4.1%
c	9539	4.0%
A	8503	3.6%
Other values (16)	75238	31.5%

ArrivalDateWeekNumber
Real number (ℝ)

Distinct	53
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	27.140864

Minimum	1
Maximum	53
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	313.1 KiB

Quantile statistics

Minimum	1
5-th percentile	5
Q1	16
median	28
Q3	38
95-th percentile	50
Maximum	53
Range	52
Interquartile range (IQR)	22

Descriptive statistics

Standard deviation	14.005441
Coefficient of variation (CV)	0.51602783
Kurtosis	-1.0320734
Mean	27.140864
Median Absolute Deviation (MAD)	11
Skewness	-0.010016716
Sum	1087263
Variance	196.15238
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
33	1197	3.0%
31	1101	2.7%
34	1090	2.7%
30	1076	2.7%
32	1054	2.6%
29	1037	2.6%
18	1012	2.5%
28	988	2.5%
35	951	2.4%
43	917	2.3%
Other values (43)	29637	74.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	343	0.9%
2	457	1.1%
3	553	1.4%
4	519	1.3%
5	501	1.3%
6	682	1.7%
7	904	2.3%
8	719	1.8%
9	795	2.0%
10	727	1.8%

Value	Count	Frequency (%)
53	618	1.5%
52	592	1.5%
51	430	1.1%
50	449	1.1%
49	716	1.8%
48	493	1.2%
47	708	1.8%
46	514	1.3%
45	690	1.7%
44	726	1.8%

ArrivalDateDayOfMonth
Real number (ℝ)

Distinct	31
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	15.821243

Minimum	1
Maximum	31
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	313.1 KiB

Quantile statistics

Minimum	1
5-th percentile	2
Q1	8
median	16
Q3	24
95-th percentile	30
Maximum	31
Range	30
Interquartile range (IQR)	16

Descriptive statistics

Standard deviation	8.8837079
Coefficient of variation (CV)	0.56150505
Kurtosis	-1.1991534
Mean	15.821243
Median Absolute Deviation (MAD)	8
Skewness	0.0063741858
Sum	633799
Variance	78.920266
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=31)

Value	Count	Frequency (%)
12	1577	3.9%
30	1473	3.7%
5	1460	3.6%
16	1426	3.6%
9	1404	3.5%
26	1399	3.5%
17	1394	3.5%
2	1388	3.5%
18	1378	3.4%
24	1370	3.4%
Other values (21)	25791	64.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	1294	3.2%
2	1388	3.5%
3	1325	3.3%
4	1302	3.3%
5	1460	3.6%
6	1192	3.0%
7	1206	3.0%
8	1245	3.1%
9	1404	3.5%
10	1185	3.0%

Value	Count	Frequency (%)
31	856	2.1%
30	1473	3.7%
29	1214	3.0%
28	1276	3.2%
27	1265	3.2%
26	1399	3.5%
25	1337	3.3%
24	1370	3.4%
23	1169	2.9%
22	1270	3.2%

StaysInWeekendNights
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	16
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1.1898153

Minimum	0
Maximum	19
Zeros	14181
Zeros (%)	35.4%
Negative	0
Negative (%)	0.0%
Memory size	313.1 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	1
Q3	2
95-th percentile	3
Maximum	19
Range	19
Interquartile range (IQR)	2

Descriptive statistics

Standard deviation	1.1478122
Coefficient of variation (CV)	0.96469782
Kurtosis	7.5634483
Mean	1.1898153
Median Absolute Deviation (MAD)	1
Skewness	1.3925394
Sum	47664
Variance	1.3174728
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=16)

Value	Count	Frequency (%)
0	14181	35.4%
2	13975	34.9%
1	9192	22.9%
4	1558	3.9%
3	936	2.3%
6	113	0.3%
8	36	0.1%
5	35	0.1%
7	13	< 0.1%
12	5	< 0.1%
Other values (6)	16	< 0.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	14181	35.4%
1	9192	22.9%
2	13975	34.9%
3	936	2.3%
4	1558	3.9%
5	35	0.1%
6	113	0.3%
7	13	< 0.1%
8	36	0.1%
9	5	< 0.1%

Value	Count	Frequency (%)
19	1	< 0.1%
18	1	< 0.1%
16	2	< 0.1%
13	2	< 0.1%
12	5	< 0.1%
10	5	< 0.1%
9	5	< 0.1%
8	36	0.1%
7	13	< 0.1%
6	113	0.3%

StaysInWeekNights
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	31
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	3.1287319

Minimum	0
Maximum	50
Zeros	2682
Zeros (%)	6.7%
Negative	0
Negative (%)	0.0%
Memory size	313.1 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	1
median	3
Q3	5
95-th percentile	7
Maximum	50
Range	50
Interquartile range (IQR)	4

Descriptive statistics

Standard deviation	2.4613294
Coefficient of variation (CV)	0.78668594
Kurtosis	15.627246
Mean	3.1287319
Median Absolute Deviation (MAD)	2
Skewness	2.2526292
Sum	125337
Variance	6.0581425
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=31)

Value	Count	Frequency (%)
1	9222	23.0%
5	7811	19.5%
2	7281	18.2%
3	5887	14.7%
4	3422	8.5%
0	2682	6.7%
6	1120	2.8%
10	891	2.2%
7	828	2.1%
8	496	1.2%
Other values (21)	420	1.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	2682	6.7%
1	9222	23.0%
2	7281	18.2%
3	5887	14.7%
4	3422	8.5%
5	7811	19.5%
6	1120	2.8%
7	828	2.1%
8	496	1.2%
9	158	0.4%

Value	Count	Frequency (%)
50	1	< 0.1%
42	1	< 0.1%
40	2	< 0.1%
33	1	< 0.1%
32	1	< 0.1%
30	4	< 0.1%
26	1	< 0.1%
25	5	< 0.1%
24	1	< 0.1%
22	1	< 0.1%

Adults
Real number (ℝ)

Distinct	14
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1.8671493

Minimum	0
Maximum	55
Zeros	13
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	313.1 KiB

Quantile statistics

Minimum	0
5-th percentile	1
Q1	2
median	2
Q3	2
95-th percentile	2
Maximum	55
Range	55
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	0.69728549
Coefficient of variation (CV)	0.37344925
Kurtosis	1916.4281
Mean	1.8671493
Median Absolute Deviation (MAD)	0
Skewness	31.610759
Sum	74798
Variance	0.48620706
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=14)

Value	Count	Frequency (%)
2	31425	78.4%
1	7148	17.8%
3	1427	3.6%
4	31	0.1%
0	13	< 0.1%
26	5	< 0.1%
27	2	< 0.1%
20	2	< 0.1%
5	2	< 0.1%
40	1	< 0.1%
Other values (4)	4	< 0.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	13	< 0.1%
1	7148	17.8%
2	31425	78.4%
3	1427	3.6%
4	31	0.1%
5	2	< 0.1%
6	1	< 0.1%
10	1	< 0.1%
20	2	< 0.1%
26	5	< 0.1%

Value	Count	Frequency (%)
55	1	< 0.1%
50	1	< 0.1%
40	1	< 0.1%
27	2	< 0.1%
26	5	< 0.1%
20	2	< 0.1%
10	1	< 0.1%
6	1	< 0.1%
5	2	< 0.1%
4	31	0.1%

Children
Categorical

Distinct	5
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	313.1 KiB

0	36576
1	1838
2	1628
3	17
10	1

Length

Max length	2
Median length	1
Mean length	1.000025
Min length	1

Characters and Unicode

Total characters	40061
Distinct characters	4
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1 ?
Unique (%)	< 0.1%

Sample

1st row	0
2nd row	0
3rd row	0
4th row	0
5th row	0

Common Values

Value	Count	Frequency (%)
0	36576	91.3%
1	1838	4.6%
2	1628	4.1%
3	17	< 0.1%
10	1	< 0.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
0	36576	91.3%
1	1838	4.6%
2	1628	4.1%
3	17	< 0.1%
10	1	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
0	36577	91.3%
1	1839	4.6%
2	1628	4.1%
3	17	< 0.1%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	40061	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	36577	91.3%
1	1839	4.6%
2	1628	4.1%
3	17	< 0.1%

Most occurring scripts

Value	Count	Frequency (%)
Common	40061	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	36577	91.3%
1	1839	4.6%
2	1628	4.1%
3	17	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	40061	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	36577	91.3%
1	1839	4.6%
2	1628	4.1%
3	17	< 0.1%

Babies
Categorical

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	313.1 KiB

0	39512
1	539
2	9

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	40060
Distinct characters	3
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0
2nd row	0
3rd row	0
4th row	0
5th row	0

Common Values

Value	Count	Frequency (%)
0	39512	98.6%
1	539	1.3%
2	9	< 0.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
0	39512	98.6%
1	539	1.3%
2	9	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
0	39512	98.6%
1	539	1.3%
2	9	< 0.1%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	40060	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	39512	98.6%
1	539	1.3%
2	9	< 0.1%

Most occurring scripts

Value	Count	Frequency (%)
Common	40060	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	39512	98.6%
1	539	1.3%
2	9	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	40060	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	39512	98.6%
1	539	1.3%
2	9	< 0.1%

Meal
Categorical

Distinct	5
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	313.1 KiB

BB	30005
HB	8046
Undefined	1169
FB	754
SC	86

Length

Max length	9
Median length	9
Mean length	9
Min length	9

Characters and Unicode

Total characters	360540
Distinct characters	12
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	BB
2nd row	BB
3rd row	BB
4th row	BB
5th row	BB

Common Values

Value	Count	Frequency (%)
BB	30005	74.9%
HB	8046	20.1%
Undefined	1169	2.9%
FB	754	1.9%
SC	86	0.2%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
bb	30005	74.9%
hb	8046	20.1%
undefined	1169	2.9%
fb	754	1.9%
sc	86	0.2%

Most occurring characters

Value	Count	Frequency (%)
	272237	75.5%
B	68810	19.1%
H	8046	2.2%
n	2338	0.6%
d	2338	0.6%
e	2338	0.6%
U	1169	0.3%
f	1169	0.3%
i	1169	0.3%
F	754	0.2%
Other values (2)	172	< 0.1%

Most occurring categories

Value	Count	Frequency (%)
Space Separator	272237	75.5%
Uppercase Letter	78951	21.9%
Lowercase Letter	9352	2.6%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
B	68810	87.2%
H	8046	10.2%
U	1169	1.5%
F	754	1.0%
S	86	0.1%
C	86	0.1%

Lowercase Letter

Value	Count	Frequency (%)
n	2338	25.0%
d	2338	25.0%
e	2338	25.0%
f	1169	12.5%
i	1169	12.5%

Space Separator

Value	Count	Frequency (%)
	272237	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	272237	75.5%
Latin	88303	24.5%

Most frequent character per script

Latin

Value	Count	Frequency (%)
B	68810	77.9%
H	8046	9.1%
n	2338	2.6%
d	2338	2.6%
e	2338	2.6%
U	1169	1.3%
f	1169	1.3%
i	1169	1.3%
F	754	0.9%
S	86	0.1%

Common

Value	Count	Frequency (%)
	272237	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	360540	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
	272237	75.5%
B	68810	19.1%
H	8046	2.2%
n	2338	0.6%
d	2338	0.6%
e	2338	0.6%
U	1169	0.3%
f	1169	0.3%
i	1169	0.3%
F	754	0.2%
Other values (2)	172	< 0.1%

Country
Categorical

HIGH CARDINALITY IMBALANCE MISSING

Distinct	125
Distinct (%)	0.3%
Missing	464
Missing (%)	1.2%
Memory size	313.1 KiB

PRT	17630
GBR	6814
ESP	3957
IRL	2166
FRA	1611
Other values (120)	7418

Length

Max length	3
Median length	3
Mean length	2.9820689
Min length	2

Characters and Unicode

Total characters	118078
Distinct characters	26
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	30 ?
Unique (%)	0.1%

Sample

1st row	PRT
2nd row	PRT
3rd row	GBR
4th row	GBR
5th row	GBR

Common Values

Value	Count	Frequency (%)
PRT	17630	44.0%
GBR	6814	17.0%
ESP	3957	9.9%
IRL	2166	5.4%
FRA	1611	4.0%
DEU	1203	3.0%
CN	710	1.8%
NLD	514	1.3%
USA	479	1.2%
ITA	459	1.1%
Other values (115)	4053	10.1%
(Missing)	464	1.2%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
prt	17630	44.5%
gbr	6814	17.2%
esp	3957	10.0%
irl	2166	5.5%
fra	1611	4.1%
deu	1203	3.0%
cn	710	1.8%
nld	514	1.3%
usa	479	1.2%
ita	459	1.2%
Other values (115)	4053	10.2%

Most occurring characters

Value	Count	Frequency (%)
R	29444	24.9%
P	21978	18.6%
T	18427	15.6%
B	7744	6.6%
G	6958	5.9%
E	6451	5.5%
S	5138	4.4%
L	3710	3.1%
A	3558	3.0%
I	2889	2.4%
Other values (16)	11781	10.0%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	118078	100.0%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
R	29444	24.9%
P	21978	18.6%
T	18427	15.6%
B	7744	6.6%
G	6958	5.9%
E	6451	5.5%
S	5138	4.4%
L	3710	3.1%
A	3558	3.0%
I	2889	2.4%
Other values (16)	11781	10.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	118078	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
R	29444	24.9%
P	21978	18.6%
T	18427	15.6%
B	7744	6.6%
G	6958	5.9%
E	6451	5.5%
S	5138	4.4%
L	3710	3.1%
A	3558	3.0%
I	2889	2.4%
Other values (16)	11781	10.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	118078	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
R	29444	24.9%
P	21978	18.6%
T	18427	15.6%
B	7744	6.6%
G	6958	5.9%
E	6451	5.5%
S	5138	4.4%
L	3710	3.1%
A	3558	3.0%
I	2889	2.4%
Other values (16)	11781	10.0%

MarketSegment
Categorical

Distinct	6
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	313.1 KiB

Online TA	17729
Offline TA/TO	7472
Direct	6513
Groups	5836
Corporate	2309

Length

Max length	13
Median length	9
Mean length	8.841363
Min length	6

Characters and Unicode

Total characters	354185
Distinct characters	23
Distinct categories	4 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Direct
2nd row	Direct
3rd row	Direct
4th row	Corporate
5th row	Online TA

Common Values

Value	Count	Frequency (%)
Online TA	17729	44.3%
Offline TA/TO	7472	18.7%
Direct	6513	16.3%
Groups	5836	14.6%
Corporate	2309	5.8%
Complementary	201	0.5%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
online	17729	27.2%
ta	17729	27.2%
offline	7472	11.4%
ta/to	7472	11.4%
direct	6513	10.0%
groups	5836	8.9%
corporate	2309	3.5%
complementary	201	0.3%

Most occurring characters

Value	Count	Frequency (%)
n	43131	12.2%
e	34425	9.7%
O	32673	9.2%
T	32673	9.2%
i	31714	9.0%
l	25402	7.2%
	25201	7.1%
A	25201	7.1%
r	17168	4.8%
f	14944	4.2%
Other values (13)	71653	20.2%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	216106	61.0%
Uppercase Letter	105406	29.8%
Space Separator	25201	7.1%
Other Punctuation	7472	2.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
n	43131	20.0%
e	34425	15.9%
i	31714	14.7%
l	25402	11.8%
r	17168	7.9%
f	14944	6.9%
o	10655	4.9%
t	9023	4.2%
p	8346	3.9%
c	6513	3.0%
Other values (5)	14785	6.8%

Uppercase Letter

Value	Count	Frequency (%)
O	32673	31.0%
T	32673	31.0%
A	25201	23.9%
D	6513	6.2%
G	5836	5.5%
C	2510	2.4%

Space Separator

Value	Count	Frequency (%)
	25201	100.0%

Other Punctuation

Value	Count	Frequency (%)
/	7472	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	321512	90.8%
Common	32673	9.2%

Most frequent character per script

Latin

Value	Count	Frequency (%)
n	43131	13.4%
e	34425	10.7%
O	32673	10.2%
T	32673	10.2%
i	31714	9.9%
l	25402	7.9%
A	25201	7.8%
r	17168	5.3%
f	14944	4.6%
o	10655	3.3%
Other values (11)	53526	16.6%

Common

Value	Count	Frequency (%)
	25201	77.1%
/	7472	22.9%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	354185	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
n	43131	12.2%
e	34425	9.7%
O	32673	9.2%
T	32673	9.2%
i	31714	9.0%
l	25402	7.2%
	25201	7.1%
A	25201	7.1%
r	17168	4.8%
f	14944	4.2%
Other values (13)	71653	20.2%

DistributionChannel
Categorical

Distinct	4
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	313.1 KiB

TA/TO	28925
Direct	7865
Corporate	3269
Undefined	1

Length

Max length	9
Median length	5
Mean length	5.5228407
Min length	5

Characters and Unicode

Total characters	221245
Distinct characters	18
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1 ?
Unique (%)	< 0.1%

Sample

1st row	Direct
2nd row	Direct
3rd row	Direct
4th row	Corporate
5th row	TA/TO

Common Values

Value	Count	Frequency (%)
TA/TO	28925	72.2%
Direct	7865	19.6%
Corporate	3269	8.2%
Undefined	1	< 0.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
ta/to	28925	72.2%
direct	7865	19.6%
corporate	3269	8.2%
undefined	1	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
T	57850	26.1%
/	28925	13.1%
O	28925	13.1%
A	28925	13.1%
r	14403	6.5%
e	11136	5.0%
t	11134	5.0%
i	7866	3.6%
c	7865	3.6%
D	7865	3.6%
Other values (8)	16351	7.4%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	126835	57.3%
Lowercase Letter	65485	29.6%
Other Punctuation	28925	13.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
r	14403	22.0%
e	11136	17.0%
t	11134	17.0%
i	7866	12.0%
c	7865	12.0%
o	6538	10.0%
p	3269	5.0%
a	3269	5.0%
n	2	< 0.1%
d	2	< 0.1%

Uppercase Letter

Value	Count	Frequency (%)
T	57850	45.6%
O	28925	22.8%
A	28925	22.8%
D	7865	6.2%
C	3269	2.6%
U	1	< 0.1%

Other Punctuation

Value	Count	Frequency (%)
/	28925	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	192320	86.9%
Common	28925	13.1%

Most frequent character per script

Latin

Value	Count	Frequency (%)
T	57850	30.1%
O	28925	15.0%
A	28925	15.0%
r	14403	7.5%
e	11136	5.8%
t	11134	5.8%
i	7866	4.1%
c	7865	4.1%
D	7865	4.1%
o	6538	3.4%
Other values (7)	9813	5.1%

Common

Value	Count	Frequency (%)
/	28925	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	221245	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
T	57850	26.1%
/	28925	13.1%
O	28925	13.1%
A	28925	13.1%
r	14403	6.5%
e	11136	5.0%
t	11134	5.0%
i	7866	3.6%
c	7865	3.6%
D	7865	3.6%
Other values (8)	16351	7.4%

IsRepeatedGuest
Categorical

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	313.1 KiB

0	38282
1	1778

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	40060
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0
2nd row	0
3rd row	0
4th row	0
5th row	0

Common Values

Value	Count	Frequency (%)
0	38282	95.6%
1	1778	4.4%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
0	38282	95.6%
1	1778	4.4%

Most occurring characters

Value	Count	Frequency (%)
0	38282	95.6%
1	1778	4.4%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	40060	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	38282	95.6%
1	1778	4.4%

Most occurring scripts

Value	Count	Frequency (%)
Common	40060	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	38282	95.6%
1	1778	4.4%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	40060	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	38282	95.6%
1	1778	4.4%

PreviousCancellations
Real number (ℝ)

Distinct	11
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.10172242

Minimum	0
Maximum	26
Zeros	38965
Zeros (%)	97.3%
Negative	0
Negative (%)	0.0%
Memory size	313.1 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	0
Maximum	26
Range	26
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	1.3351153
Coefficient of variation (CV)	13.125084
Kurtosis	310.61435
Mean	0.10172242
Median Absolute Deviation (MAD)	0
Skewness	17.417627
Sum	4075
Variance	1.7825328
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=11)

Value	Count	Frequency (%)
0	38965	97.3%
1	896	2.2%
24	48	0.1%
2	44	0.1%
26	26	0.1%
25	25	0.1%
19	19	< 0.1%
3	14	< 0.1%
14	14	< 0.1%
4	6	< 0.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	38965	97.3%
1	896	2.2%
2	44	0.1%
3	14	< 0.1%
4	6	< 0.1%
5	3	< 0.1%
14	14	< 0.1%
19	19	< 0.1%
24	48	0.1%
25	25	0.1%

Value	Count	Frequency (%)
26	26	0.1%
25	25	0.1%
24	48	0.1%
19	19	< 0.1%
14	14	< 0.1%
5	3	< 0.1%
4	6	< 0.1%
3	14	< 0.1%
2	44	0.1%
1	896	2.2%

PreviousBookingsNotCanceled
Real number (ℝ)

Distinct	31
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.14645532

Minimum	0
Maximum	30
Zeros	38028
Zeros (%)	94.9%
Negative	0
Negative (%)	0.0%
Memory size	313.1 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	1
Maximum	30
Range	30
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	1.0019545
Coefficient of variation (CV)	6.8413668
Kurtosis	244.37828
Mean	0.14645532
Median Absolute Deviation (MAD)	0
Skewness	13.241518
Sum	5867
Variance	1.0039129
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=31)

Value	Count	Frequency (%)
0	38028	94.9%
1	973	2.4%
2	388	1.0%
3	204	0.5%
4	127	0.3%
5	91	0.2%
6	56	0.1%
7	37	0.1%
8	33	0.1%
9	24	0.1%
Other values (21)	99	0.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	38028	94.9%
1	973	2.4%
2	388	1.0%
3	204	0.5%
4	127	0.3%
5	91	0.2%
6	56	0.1%
7	37	0.1%
8	33	0.1%
9	24	0.1%

Value	Count	Frequency (%)
30	1	< 0.1%
29	1	< 0.1%
28	1	< 0.1%
27	2	< 0.1%
26	1	< 0.1%
25	3	< 0.1%
24	2	< 0.1%
23	2	< 0.1%
22	2	< 0.1%
21	2	< 0.1%

ReservedRoomType
Categorical

Distinct	10
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	313.1 KiB

A	23399
D	7433
E	4982
G	1610
F	1106
Other values (5)	1530

Length

Max length	16
Median length	16
Mean length	16
Min length	16

Characters and Unicode

Total characters	640960
Distinct characters	11
Distinct categories	2 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	C
2nd row	C
3rd row	A
4th row	A
5th row	A

Common Values

Value	Count	Frequency (%)
A	23399	58.4%
D	7433	18.6%
E	4982	12.4%
G	1610	4.0%
F	1106	2.8%
C	918	2.3%
H	601	1.5%
L	6	< 0.1%
B	3	< 0.1%
P	2	< 0.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
a	23399	58.4%
d	7433	18.6%
e	4982	12.4%
g	1610	4.0%
f	1106	2.8%
c	918	2.3%
h	601	1.5%
l	6	< 0.1%
b	3	< 0.1%
p	2	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
	600900	93.8%
A	23399	3.7%
D	7433	1.2%
E	4982	0.8%
G	1610	0.3%
F	1106	0.2%
C	918	0.1%
H	601	0.1%
L	6	< 0.1%
B	3	< 0.1%

Most occurring categories

Value	Count	Frequency (%)
Space Separator	600900	93.8%
Uppercase Letter	40060	6.2%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
A	23399	58.4%
D	7433	18.6%
E	4982	12.4%
G	1610	4.0%
F	1106	2.8%
C	918	2.3%
H	601	1.5%
L	6	< 0.1%
B	3	< 0.1%
P	2	< 0.1%

Space Separator

Value	Count	Frequency (%)
	600900	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	600900	93.8%
Latin	40060	6.2%

Most frequent character per script

Latin

Value	Count	Frequency (%)
A	23399	58.4%
D	7433	18.6%
E	4982	12.4%
G	1610	4.0%
F	1106	2.8%
C	918	2.3%
H	601	1.5%
L	6	< 0.1%
B	3	< 0.1%
P	2	< 0.1%

Common

Value	Count	Frequency (%)
	600900	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	640960	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
	600900	93.8%
A	23399	3.7%
D	7433	1.2%
E	4982	0.8%
G	1610	0.3%
F	1106	0.2%
C	918	0.1%
H	601	0.1%
L	6	< 0.1%
B	3	< 0.1%

AssignedRoomType
Categorical

Distinct	11
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	313.1 KiB

A	17046
D	10339
E	5638
C	2214
G	1853
Other values (6)	2970

Length

Max length	16
Median length	16
Mean length	16
Min length	16

Characters and Unicode

Total characters	640960
Distinct characters	12
Distinct categories	2 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1 ?
Unique (%)	< 0.1%

Sample

1st row	C
2nd row	C
3rd row	C
4th row	A
5th row	A

Common Values

Value	Count	Frequency (%)
A	17046	42.6%
D	10339	25.8%
E	5638	14.1%
C	2214	5.5%
G	1853	4.6%
F	1733	4.3%
H	712	1.8%
I	363	0.9%
B	159	0.4%
P	2	< 0.1%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
a	17046	42.6%
d	10339	25.8%
e	5638	14.1%
c	2214	5.5%
g	1853	4.6%
f	1733	4.3%
h	712	1.8%
i	363	0.9%
b	159	0.4%
p	2	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
	600900	93.8%
A	17046	2.7%
D	10339	1.6%
E	5638	0.9%
C	2214	0.3%
G	1853	0.3%
F	1733	0.3%
H	712	0.1%
I	363	0.1%
B	159	< 0.1%
Other values (2)	3	< 0.1%

Most occurring categories

Value	Count	Frequency (%)
Space Separator	600900	93.8%
Uppercase Letter	40060	6.2%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
A	17046	42.6%
D	10339	25.8%
E	5638	14.1%
C	2214	5.5%
G	1853	4.6%
F	1733	4.3%
H	712	1.8%
I	363	0.9%
B	159	0.4%
P	2	< 0.1%

Space Separator

Value	Count	Frequency (%)
	600900	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	600900	93.8%
Latin	40060	6.2%

Most frequent character per script

Latin

Value	Count	Frequency (%)
A	17046	42.6%
D	10339	25.8%
E	5638	14.1%
C	2214	5.5%
G	1853	4.6%
F	1733	4.3%
H	712	1.8%
I	363	0.9%
B	159	0.4%
P	2	< 0.1%

Common

Value	Count	Frequency (%)
	600900	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	640960	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
	600900	93.8%
A	17046	2.7%
D	10339	1.6%
E	5638	0.9%
C	2214	0.3%
G	1853	0.3%
F	1733	0.3%
H	712	0.1%
I	363	0.1%
B	159	< 0.1%
Other values (2)	3	< 0.1%

BookingChanges
Real number (ℝ)

Distinct	15
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.28796805

Minimum	0
Maximum	17
Zeros	32252
Zeros (%)	80.5%
Negative	0
Negative (%)	0.0%
Memory size	313.1 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	2
Maximum	17
Range	17
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	0.72654759
Coefficient of variation (CV)	2.5230146
Kurtosis	37.894806
Mean	0.28796805
Median Absolute Deviation (MAD)	0
Skewness	4.4244027
Sum	11536
Variance	0.5278714
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=15)

Value	Count	Frequency (%)
0	32252	80.5%
1	5469	13.7%
2	1561	3.9%
3	460	1.1%
4	182	0.5%
5	72	0.2%
6	32	0.1%
7	12	< 0.1%
8	8	< 0.1%
9	4	< 0.1%
Other values (5)	8	< 0.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	32252	80.5%
1	5469	13.7%
2	1561	3.9%
3	460	1.1%
4	182	0.5%
5	72	0.2%
6	32	0.1%
7	12	< 0.1%
8	8	< 0.1%
9	4	< 0.1%

Value	Count	Frequency (%)
17	1	< 0.1%
16	1	< 0.1%
13	2	< 0.1%
12	1	< 0.1%
10	3	< 0.1%
9	4	< 0.1%
8	8	< 0.1%
7	12	< 0.1%
6	32	0.1%
5	72	0.2%

DepositType
Categorical

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	313.1 KiB

No Deposit	38199
Non Refund	1719
Refundable	142

Length

Max length	15
Median length	15
Mean length	15
Min length	15

Characters and Unicode

Total characters	600900
Distinct characters	17
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	No Deposit
2nd row	No Deposit
3rd row	No Deposit
4th row	No Deposit
5th row	No Deposit

Common Values

Value	Count	Frequency (%)
No Deposit	38199	95.4%
Non Refund	1719	4.3%
Refundable	142	0.4%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
no	38199	47.8%
deposit	38199	47.8%
non	1719	2.1%
refund	1719	2.1%
refundable	142	0.2%

Most occurring characters

Value	Count	Frequency (%)
	240218	40.0%
o	78117	13.0%
e	40202	6.7%
N	39918	6.6%
s	38199	6.4%
i	38199	6.4%
t	38199	6.4%
p	38199	6.4%
D	38199	6.4%
n	3580	0.6%
Other values (7)	7870	1.3%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	280704	46.7%
Space Separator	240218	40.0%
Uppercase Letter	79978	13.3%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
o	78117	27.8%
e	40202	14.3%
s	38199	13.6%
i	38199	13.6%
t	38199	13.6%
p	38199	13.6%
n	3580	1.3%
f	1861	0.7%
u	1861	0.7%
d	1861	0.7%
Other values (3)	426	0.2%

Uppercase Letter

Value	Count	Frequency (%)
N	39918	49.9%
D	38199	47.8%
R	1861	2.3%

Space Separator

Value	Count	Frequency (%)
	240218	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	360682	60.0%
Common	240218	40.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
o	78117	21.7%
e	40202	11.1%
N	39918	11.1%
s	38199	10.6%
i	38199	10.6%
t	38199	10.6%
p	38199	10.6%
D	38199	10.6%
n	3580	1.0%
R	1861	0.5%
Other values (6)	6009	1.7%

Common

Value	Count	Frequency (%)
	240218	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	600900	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
	240218	40.0%
o	78117	13.0%
e	40202	6.7%
N	39918	6.6%
s	38199	6.4%
i	38199	6.4%
t	38199	6.4%
p	38199	6.4%
D	38199	6.4%
n	3580	0.6%
Other values (7)	7870	1.3%

Agent
Categorical

Distinct	186
Distinct (%)	0.5%
Missing	0
Missing (%)	0.0%
Memory size	313.1 KiB

240	13905
NULL	8209
250	2869
241	1721
40	1002
Other values (181)	12354

Length

Max length	11
Median length	11
Mean length	11
Min length	11

Characters and Unicode

Total characters	440660
Distinct characters	14
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	36 ?
Unique (%)	0.1%

Sample

1st row	NULL
2nd row	NULL
3rd row	NULL
4th row	304
5th row	240

Common Values

Value	Count	Frequency (%)
240	13905	34.7%
NULL	8209	20.5%
250	2869	7.2%
241	1721	4.3%
40	1002	2.5%
314	927	2.3%
242	779	1.9%
6	607	1.5%
96	537	1.3%
243	514	1.3%
Other values (176)	8990	22.4%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
240	13905	34.7%
null	8209	20.5%
250	2869	7.2%
241	1721	4.3%
40	1002	2.5%
314	927	2.3%
242	779	1.9%
6	607	1.5%
96	537	1.3%
243	514	1.3%
Other values (176)	8990	22.4%

Most occurring characters

Value	Count	Frequency (%)
	318055	72.2%
2	23086	5.2%
4	21011	4.8%
0	18600	4.2%
L	16418	3.7%
N	8209	1.9%
U	8209	1.9%
1	7873	1.8%
5	5514	1.3%
3	4338	1.0%
Other values (4)	9347	2.1%

Most occurring categories

Value	Count	Frequency (%)
Space Separator	318055	72.2%
Decimal Number	89769	20.4%
Uppercase Letter	32836	7.5%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
2	23086	25.7%
4	21011	23.4%
0	18600	20.7%
1	7873	8.8%
5	5514	6.1%
3	4338	4.8%
6	2926	3.3%
7	2303	2.6%
8	2206	2.5%
9	1912	2.1%

Uppercase Letter

Value	Count	Frequency (%)
L	16418	50.0%
N	8209	25.0%
U	8209	25.0%

Space Separator

Value	Count	Frequency (%)
	318055	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	407824	92.5%
Latin	32836	7.5%

Most frequent character per script

Common

Value	Count	Frequency (%)
	318055	78.0%
2	23086	5.7%
4	21011	5.2%
0	18600	4.6%
1	7873	1.9%
5	5514	1.4%
3	4338	1.1%
6	2926	0.7%
7	2303	0.6%
8	2206	0.5%

Latin

Value	Count	Frequency (%)
L	16418	50.0%
N	8209	25.0%
U	8209	25.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	440660	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
	318055	72.2%
2	23086	5.2%
4	21011	4.8%
0	18600	4.2%
L	16418	3.7%
N	8209	1.9%
U	8209	1.9%
1	7873	1.8%
5	5514	1.3%
3	4338	1.0%
Other values (4)	9347	2.1%

Company
Categorical

HIGH CARDINALITY IMBALANCE

Distinct	236
Distinct (%)	0.6%
Missing	0
Missing (%)	0.0%
Memory size	313.1 KiB

NULL	36952
223	784
281	138
154	133
405	100
Other values (231)	1953

Length

Max length	11
Median length	11
Mean length	11
Min length	11

Characters and Unicode

Total characters	440660
Distinct characters	14
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	68 ?
Unique (%)	0.2%

Sample

1st row	NULL
2nd row	NULL
3rd row	NULL
4th row	NULL
5th row	NULL

Common Values

Value	Count	Frequency (%)
NULL	36952	92.2%
223	784	2.0%
281	138	0.3%
154	133	0.3%
405	100	0.2%
94	87	0.2%
135	64	0.2%
331	58	0.1%
498	58	0.1%
47	56	0.1%
Other values (226)	1630	4.1%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
null	36952	92.2%
223	784	2.0%
281	138	0.3%
154	133	0.3%
405	100	0.2%
94	87	0.2%
135	64	0.2%
331	58	0.1%
498	58	0.1%
47	56	0.1%
Other values (226)	1630	4.1%

Most occurring characters

Value	Count	Frequency (%)
	284028	64.5%
L	73904	16.8%
N	36952	8.4%
U	36952	8.4%
2	2353	0.5%
3	1673	0.4%
1	1019	0.2%
4	897	0.2%
5	626	0.1%
8	536	0.1%
Other values (4)	1720	0.4%

Most occurring categories

Value	Count	Frequency (%)
Space Separator	284028	64.5%
Uppercase Letter	147808	33.5%
Decimal Number	8824	2.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
2	2353	26.7%
3	1673	19.0%
1	1019	11.5%
4	897	10.2%
5	626	7.1%
8	536	6.1%
0	536	6.1%
9	494	5.6%
7	428	4.9%
6	262	3.0%

Uppercase Letter

Value	Count	Frequency (%)
L	73904	50.0%
N	36952	25.0%
U	36952	25.0%

Space Separator

Value	Count	Frequency (%)
	284028	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	292852	66.5%
Latin	147808	33.5%

Most frequent character per script

Common

Value	Count	Frequency (%)
	284028	97.0%
2	2353	0.8%
3	1673	0.6%
1	1019	0.3%
4	897	0.3%
5	626	0.2%
8	536	0.2%
0	536	0.2%
9	494	0.2%
7	428	0.1%

Latin

Value	Count	Frequency (%)
L	73904	50.0%
N	36952	25.0%
U	36952	25.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	440660	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
	284028	64.5%
L	73904	16.8%
N	36952	8.4%
U	36952	8.4%
2	2353	0.5%
3	1673	0.4%
1	1019	0.2%
4	897	0.2%
5	626	0.1%
8	536	0.1%
Other values (4)	1720	0.4%

DaysInWaitingList
Real number (ℝ)

Distinct	44
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.52775836

Minimum	0
Maximum	185
Zeros	39805
Zeros (%)	99.4%
Negative	0
Negative (%)	0.0%
Memory size	313.1 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	0
Maximum	185
Range	185
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	7.4285804
Coefficient of variation (CV)	14.075723
Kurtosis	251.48458
Mean	0.52775836
Median Absolute Deviation (MAD)	0
Skewness	15.436884
Sum	21142
Variance	55.183807
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=44)

Value	Count	Frequency (%)
0	39805	99.4%
122	55	0.1%
65	27	0.1%
47	23	0.1%
75	20	< 0.1%
101	18	< 0.1%
125	16	< 0.1%
150	11	< 0.1%
14	6	< 0.1%
60	5	< 0.1%
Other values (34)	74	0.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	39805	99.4%
1	5	< 0.1%
2	2	< 0.1%
4	3	< 0.1%
5	3	< 0.1%
6	4	< 0.1%
8	3	< 0.1%
11	1	< 0.1%
13	2	< 0.1%
14	6	< 0.1%

Value	Count	Frequency (%)
185	2	< 0.1%
154	2	< 0.1%
150	11	< 0.1%
142	1	< 0.1%
125	16	< 0.1%
122	55	0.1%
121	2	< 0.1%
116	1	< 0.1%
113	5	< 0.1%
109	1	< 0.1%

CustomerType
Categorical

Distinct	4
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	313.1 KiB

Transient	30209
Transient-Party	7791
Contract	1776
Group	284

Length

Max length	15
Median length	9
Mean length	10.094209
Min length	5

Characters and Unicode

Total characters	404374
Distinct characters	17
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Transient
2nd row	Transient
3rd row	Transient
4th row	Transient
5th row	Transient

Common Values

Value	Count	Frequency (%)
Transient	30209	75.4%
Transient-Party	7791	19.4%
Contract	1776	4.4%
Group	284	0.7%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
transient	30209	75.4%
transient-party	7791	19.4%
contract	1776	4.4%
group	284	0.7%

Most occurring characters

Value	Count	Frequency (%)
n	77776	19.2%
t	49343	12.2%
r	47851	11.8%
a	47567	11.8%
T	38000	9.4%
s	38000	9.4%
i	38000	9.4%
e	38000	9.4%
y	7791	1.9%
-	7791	1.9%
Other values (7)	14255	3.5%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	348732	86.2%
Uppercase Letter	47851	11.8%
Dash Punctuation	7791	1.9%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
n	77776	22.3%
t	49343	14.1%
r	47851	13.7%
a	47567	13.6%
s	38000	10.9%
i	38000	10.9%
e	38000	10.9%
y	7791	2.2%
o	2060	0.6%
c	1776	0.5%
Other values (2)	568	0.2%

Uppercase Letter

Value	Count	Frequency (%)
T	38000	79.4%
P	7791	16.3%
C	1776	3.7%
G	284	0.6%

Dash Punctuation

Value	Count	Frequency (%)
-	7791	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	396583	98.1%
Common	7791	1.9%

Most frequent character per script

Latin

Value	Count	Frequency (%)
n	77776	19.6%
t	49343	12.4%
r	47851	12.1%
a	47567	12.0%
T	38000	9.6%
s	38000	9.6%
i	38000	9.6%
e	38000	9.6%
y	7791	2.0%
P	7791	2.0%
Other values (6)	6464	1.6%

Common

Value	Count	Frequency (%)
-	7791	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	404374	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
n	77776	19.2%
t	49343	12.2%
r	47851	11.8%
a	47567	11.8%
T	38000	9.4%
s	38000	9.4%
i	38000	9.4%
e	38000	9.4%
y	7791	1.9%
-	7791	1.9%
Other values (7)	14255	3.5%

ADR
Real number (ℝ)

Distinct	5880
Distinct (%)	14.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	94.95293

Minimum	-6.38
Maximum	508
Zeros	751
Zeros (%)	1.9%
Negative	1
Negative (%)	< 0.1%
Memory size	313.1 KiB

Quantile statistics

Minimum	-6.38
5-th percentile	30
Q1	50
median	75
Q3	125
95-th percentile	221.0035
Maximum	508
Range	514.38
Interquartile range (IQR)	75

Descriptive statistics

Standard deviation	61.442418
Coefficient of variation (CV)	0.64708291
Kurtosis	1.3400805
Mean	94.95293
Median Absolute Deviation (MAD)	30
Skewness	1.2373892
Sum	3803814.4
Variance	3775.1707
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
48	1024	2.6%
0	751	1.9%
68	489	1.2%
60	475	1.2%
80	463	1.2%
85	446	1.1%
35	417	1.0%
55	414	1.0%
40	396	1.0%
66	390	1.0%
Other values (5870)	34795	86.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-6.38	1	< 0.1%
0	751	1.9%
0.26	1	< 0.1%
1.56	2	< 0.1%
1.8	1	< 0.1%
2	5	< 0.1%
2.4	1	< 0.1%
3	1	< 0.1%
4	21	0.1%
4.5	2	< 0.1%

Value	Count	Frequency (%)
508	1	< 0.1%
450	1	< 0.1%
437	1	< 0.1%
426.25	1	< 0.1%
402	1	< 0.1%
397.38	1	< 0.1%
392	2	< 0.1%
388	2	< 0.1%
387	1	< 0.1%
384	1	< 0.1%

RequiredCarParkingSpaces
Categorical

Distinct	5
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	313.1 KiB

0	34570
1	5462
2	25
8	2
3	1

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	40060
Distinct characters	5
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1 ?
Unique (%)	< 0.1%

Sample

1st row	0
2nd row	0
3rd row	0
4th row	0
5th row	0

Common Values

Value	Count	Frequency (%)
0	34570	86.3%
1	5462	13.6%
2	25	0.1%
8	2	< 0.1%
3	1	< 0.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
0	34570	86.3%
1	5462	13.6%
2	25	0.1%
8	2	< 0.1%
3	1	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
0	34570	86.3%
1	5462	13.6%
2	25	0.1%
8	2	< 0.1%
3	1	< 0.1%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	40060	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	34570	86.3%
1	5462	13.6%
2	25	0.1%
8	2	< 0.1%
3	1	< 0.1%

Most occurring scripts

Value	Count	Frequency (%)
Common	40060	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	34570	86.3%
1	5462	13.6%
2	25	0.1%
8	2	< 0.1%
3	1	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	40060	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	34570	86.3%
1	5462	13.6%
2	25	0.1%
8	2	< 0.1%
3	1	< 0.1%

TotalOfSpecialRequests
Real number (ℝ)

Distinct	6
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.61977034

Minimum	0
Maximum	5
Zeros	22361
Zeros (%)	55.8%
Negative	0
Negative (%)	0.0%
Memory size	313.1 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	1
95-th percentile	2
Maximum	5
Range	5
Interquartile range (IQR)	1

Descriptive statistics

Standard deviation	0.8139296
Coefficient of variation (CV)	1.3132761
Kurtosis	1.2074689
Mean	0.61977034
Median Absolute Deviation (MAD)	0
Skewness	1.2477349
Sum	24828
Variance	0.66248139
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=6)

Value	Count	Frequency (%)
0	22361	55.8%
1	11806	29.5%
2	4827	12.0%
3	910	2.3%
4	142	0.4%
5	14	< 0.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	22361	55.8%
1	11806	29.5%
2	4827	12.0%
3	910	2.3%
4	142	0.4%
5	14	< 0.1%

Value	Count	Frequency (%)
5	14	< 0.1%
4	142	0.4%
3	910	2.3%
2	4827	12.0%
1	11806	29.5%
0	22361	55.8%

ReservationStatus
Categorical

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	313.1 KiB

Check-Out	28938
Canceled	10831
No-Show	291

Length

Max length	9
Median length	9
Mean length	8.7151023
Min length	7

Characters and Unicode

Total characters	349127
Distinct characters	17
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Check-Out
2nd row	Check-Out
3rd row	Check-Out
4th row	Check-Out
5th row	Check-Out

Common Values

Value	Count	Frequency (%)
Check-Out	28938	72.2%
Canceled	10831	27.0%
No-Show	291	0.7%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
check-out	28938	72.2%
canceled	10831	27.0%
no-show	291	0.7%

Most occurring characters

Value	Count	Frequency (%)
e	50600	14.5%
C	39769	11.4%
c	39769	11.4%
h	29229	8.4%
-	29229	8.4%
u	28938	8.3%
t	28938	8.3%
O	28938	8.3%
k	28938	8.3%
a	10831	3.1%
Other values (7)	33948	9.7%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	250609	71.8%
Uppercase Letter	69289	19.8%
Dash Punctuation	29229	8.4%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	50600	20.2%
c	39769	15.9%
h	29229	11.7%
u	28938	11.5%
t	28938	11.5%
k	28938	11.5%
a	10831	4.3%
n	10831	4.3%
l	10831	4.3%
d	10831	4.3%
Other values (2)	873	0.3%

Uppercase Letter

Value	Count	Frequency (%)
C	39769	57.4%
O	28938	41.8%
N	291	0.4%
S	291	0.4%

Dash Punctuation

Value	Count	Frequency (%)
-	29229	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	319898	91.6%
Common	29229	8.4%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	50600	15.8%
C	39769	12.4%
c	39769	12.4%
h	29229	9.1%
u	28938	9.0%
t	28938	9.0%
O	28938	9.0%
k	28938	9.0%
a	10831	3.4%
n	10831	3.4%
Other values (6)	23117	7.2%

Common

Value	Count	Frequency (%)
-	29229	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	349127	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
e	50600	14.5%
C	39769	11.4%
c	39769	11.4%
h	29229	8.4%
-	29229	8.4%
u	28938	8.3%
t	28938	8.3%
O	28938	8.3%
k	28938	8.3%
a	10831	3.1%
Other values (7)	33948	9.7%

ReservationStatusDate
Categorical

Distinct	913
Distinct (%)	2.3%
Missing	0
Missing (%)	0.0%
Memory size	313.1 KiB

2017-01-19	147
2016-02-09	145
2016-02-29	129
2017-02-28	124
2015-11-15	124
Other values (908)	39391

Length

Max length	10
Median length	10
Mean length	10
Min length	10

Characters and Unicode

Total characters	400600
Distinct characters	11
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	31 ?
Unique (%)	0.1%

Sample

1st row	2015-07-01
2nd row	2015-07-01
3rd row	2015-07-02
4th row	2015-07-02
5th row	2015-07-03

Common Values

Value	Count	Frequency (%)
2017-01-19	147	0.4%
2016-02-09	145	0.4%
2016-02-29	129	0.3%
2017-02-28	124	0.3%
2015-11-15	124	0.3%
2016-10-06	121	0.3%
2015-12-08	115	0.3%
2017-03-06	114	0.3%
2017-05-25	114	0.3%
2016-04-04	110	0.3%
Other values (903)	38817	96.9%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
2017-01-19	147	0.4%
2016-02-09	145	0.4%
2016-02-29	129	0.3%
2017-02-28	124	0.3%
2015-11-15	124	0.3%
2016-10-06	121	0.3%
2015-12-08	115	0.3%
2017-03-06	114	0.3%
2017-05-25	114	0.3%
2016-04-04	110	0.3%
Other values (903)	38817	96.9%

Most occurring characters

Value	Count	Frequency (%)
0	90317	22.5%
-	80120	20.0%
1	73097	18.2%
2	62895	15.7%
6	26071	6.5%
7	20218	5.0%
5	16092	4.0%
3	9521	2.4%
8	7966	2.0%
4	7211	1.8%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	320480	80.0%
Dash Punctuation	80120	20.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	90317	28.2%
1	73097	22.8%
2	62895	19.6%
6	26071	8.1%
7	20218	6.3%
5	16092	5.0%
3	9521	3.0%
8	7966	2.5%
4	7211	2.3%
9	7092	2.2%

Dash Punctuation

Value	Count	Frequency (%)
-	80120	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	400600	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	90317	22.5%
-	80120	20.0%
1	73097	18.2%
2	62895	15.7%
6	26071	6.5%
7	20218	5.0%
5	16092	4.0%
3	9521	2.4%
8	7966	2.0%
4	7211	1.8%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	400600	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	90317	22.5%
-	80120	20.0%
1	73097	18.2%
2	62895	15.7%
6	26071	6.5%
7	20218	5.0%
5	16092	4.0%
3	9521	2.4%
8	7966	2.0%
4	7211	1.8%

Auto

Heatmap
Table

	LeadTime	ArrivalDateWeekNumber	ArrivalDateDayOfMonth	StaysInWeekendNights	StaysInWeekNights	Adults	PreviousCancellations	PreviousBookingsNotCanceled	BookingChanges	DaysInWaitingList	ADR	TotalOfSpecialRequests	IsCanceled	ArrivalDateYear	ArrivalDateMonth	Children	Babies	Meal	MarketSegment	DistributionChannel	IsRepeatedGuest	ReservedRoomType	AssignedRoomType	DepositType	CustomerType	RequiredCarParkingSpaces	ReservationStatus
LeadTime	1.000	0.128	-0.012	0.421	0.526	0.235	0.114	-0.215	0.076	0.075	0.157	0.023	0.235	0.104	0.170	0.020	0.000	0.117	0.198	0.138	0.141	0.046	0.051	0.178	0.147	0.076	0.172
ArrivalDateWeekNumber	0.128	1.000	0.072	0.065	0.071	0.068	0.066	-0.073	0.014	0.049	0.139	0.041	0.108	0.421	0.799	0.084	0.033	0.099	0.154	0.129	0.125	0.065	0.051	0.130	0.146	0.011	0.083
ArrivalDateDayOfMonth	-0.012	0.072	1.000	-0.028	-0.031	0.009	-0.030	0.005	-0.002	0.030	0.039	0.012	0.034	0.037	0.062	0.013	0.005	0.050	0.044	0.053	0.015	0.014	0.013	0.096	0.046	0.010	0.026
StaysInWeekendNights	0.421	0.065	-0.028	1.000	0.574	0.183	-0.015	-0.147	0.047	-0.001	0.166	0.068	0.096	0.040	0.095	0.032	0.020	0.094	0.143	0.126	0.125	0.063	0.030	0.035	0.165	0.050	0.070
StaysInWeekNights	0.526	0.071	-0.031	0.574	1.000	0.199	-0.010	-0.159	0.086	0.047	0.207	0.069	0.035	0.030	0.063	0.000	0.000	0.072	0.085	0.044	0.042	0.038	0.026	0.031	0.131	0.040	0.025
Adults	0.235	0.068	0.009	0.183	0.199	1.000	-0.030	-0.272	-0.027	-0.008	0.395	0.155	0.028	0.023	0.019	0.000	0.000	0.000	0.012	0.011	0.000	0.000	0.000	0.000	0.127	0.000	0.019
PreviousCancellations	0.114	0.066	-0.030	-0.015	-0.010	-0.030	1.000	0.113	-0.047	-0.012	-0.077	-0.064	0.095	0.079	0.068	0.000	0.000	0.089	0.055	0.044	0.066	0.020	0.031	0.157	0.007	0.007	0.068
PreviousBookingsNotCanceled	-0.215	-0.073	0.005	-0.147	-0.159	-0.272	0.113	1.000	0.007	-0.009	-0.149	-0.005	0.058	0.039	0.022	0.003	0.000	0.024	0.119	0.133	0.309	0.017	0.008	0.008	0.037	0.017	0.040
BookingChanges	0.076	0.014	-0.002	0.047	0.086	-0.027	-0.047	0.007	1.000	0.021	0.024	0.013	0.073	0.030	0.017	0.031	0.048	0.083	0.045	0.057	0.000	0.013	0.048	0.039	0.068	0.026	0.053
DaysInWaitingList	0.075	0.049	0.030	-0.001	0.047	-0.008	-0.012	-0.009	0.021	1.000	-0.006	-0.058	0.035	0.059	0.062	0.000	0.000	0.103	0.072	0.048	0.000	0.015	0.017	0.164	0.083	0.040	0.022
ADR	0.157	0.139	0.039	0.166	0.207	0.395	-0.077	-0.149	0.024	-0.006	1.000	0.194	0.114	0.145	0.287	0.188	0.042	0.136	0.216	0.165	0.164	0.168	0.135	0.102	0.130	0.052	0.085
TotalOfSpecialRequests	0.023	0.041	0.012	0.068	0.069	0.155	-0.064	-0.005	0.013	-0.058	0.194	1.000	0.115	0.076	0.083	0.042	0.116	0.073	0.209	0.142	0.067	0.071	0.055	0.136	0.105	0.040	0.081
IsCanceled	0.235	0.108	0.034	0.096	0.035	0.028	0.095	0.058	0.073	0.035	0.114	0.115	1.000	0.047	0.115	0.087	0.023	0.110	0.253	0.136	0.103	0.081	0.183	0.323	0.141	0.247	1.000
ArrivalDateYear	0.104	0.421	0.037	0.040	0.030	0.023	0.079	0.039	0.030	0.059	0.145	0.076	0.047	1.000	0.428	0.047	0.010	0.070	0.096	0.037	0.075	0.069	0.038	0.063	0.053	0.015	0.034
ArrivalDateMonth	0.170	0.799	0.062	0.095	0.063	0.019	0.068	0.022	0.017	0.062	0.287	0.083	0.115	0.428	1.000	0.090	0.036	0.115	0.165	0.133	0.122	0.067	0.048	0.139	0.153	0.017	0.087
Children	0.020	0.084	0.013	0.032	0.000	0.000	0.000	0.003	0.031	0.000	0.188	0.042	0.087	0.047	0.090	1.000	0.048	0.031	0.101	0.055	0.046	0.420	0.357	0.045	0.066	0.029	0.074
Babies	0.000	0.033	0.005	0.020	0.000	0.000	0.000	0.000	0.048	0.000	0.042	0.116	0.023	0.010	0.036	0.048	1.000	0.020	0.044	0.029	0.020	0.059	0.065	0.017	0.018	0.025	0.015
Meal	0.117	0.099	0.050	0.094	0.072	0.000	0.089	0.024	0.083	0.103	0.136	0.073	0.110	0.070	0.115	0.031	0.020	1.000	0.207	0.076	0.074	0.100	0.234	0.184	0.145	0.038	0.081
MarketSegment	0.198	0.154	0.044	0.143	0.085	0.012	0.055	0.119	0.045	0.072	0.216	0.209	0.253	0.096	0.165	0.101	0.044	0.207	1.000	0.686	0.273	0.179	0.150	0.326	0.406	0.099	0.183
DistributionChannel	0.138	0.129	0.053	0.126	0.044	0.011	0.044	0.133	0.057	0.048	0.165	0.142	0.136	0.037	0.133	0.055	0.029	0.076	0.686	1.000	0.210	0.152	0.106	0.063	0.116	0.076	0.099
IsRepeatedGuest	0.141	0.125	0.015	0.125	0.042	0.000	0.066	0.309	0.000	0.000	0.164	0.067	0.103	0.075	0.122	0.046	0.020	0.074	0.273	0.210	1.000	0.075	0.073	0.044	0.155	0.060	0.104
ReservedRoomType	0.046	0.065	0.014	0.063	0.038	0.000	0.020	0.017	0.013	0.015	0.168	0.071	0.081	0.069	0.067	0.420	0.059	0.100	0.179	0.152	0.075	1.000	0.738	0.091	0.122	0.059	0.058
AssignedRoomType	0.051	0.051	0.013	0.030	0.026	0.000	0.031	0.008	0.048	0.017	0.135	0.055	0.183	0.038	0.048	0.357	0.065	0.234	0.150	0.106	0.073	0.738	1.000	0.127	0.101	0.073	0.131
DepositType	0.178	0.130	0.096	0.035	0.031	0.000	0.157	0.008	0.039	0.164	0.102	0.136	0.323	0.063	0.139	0.045	0.017	0.184	0.326	0.063	0.044	0.091	0.127	1.000	0.101	0.063	0.230
CustomerType	0.147	0.146	0.046	0.165	0.131	0.127	0.007	0.037	0.068	0.083	0.130	0.105	0.141	0.053	0.153	0.066	0.018	0.145	0.406	0.116	0.155	0.122	0.101	0.101	1.000	0.063	0.100
RequiredCarParkingSpaces	0.076	0.011	0.010	0.050	0.040	0.000	0.007	0.017	0.026	0.040	0.052	0.040	0.247	0.015	0.017	0.029	0.025	0.038	0.099	0.076	0.060	0.059	0.073	0.063	0.063	1.000	0.174
ReservationStatus	0.172	0.083	0.026	0.070	0.025	0.019	0.068	0.040	0.053	0.022	0.085	0.081	1.000	0.034	0.087	0.074	0.015	0.081	0.183	0.099	0.104	0.058	0.131	0.230	0.100	0.174	1.000

Count
Matrix

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

First rows
Last rows

	IsCanceled	LeadTime	ArrivalDateYear	ArrivalDateMonth	ArrivalDateWeekNumber	ArrivalDateDayOfMonth	StaysInWeekNights	Adults	Meal	Country	MarketSegment	DistributionChannel	ReservedRoomType	AssignedRoomType	BookingChanges	DepositType	Agent	Company	CustomerType	ADR	TotalOfSpecialRequests	ReservationStatus	ReservationStatusDate
0	0	342	2015	July	27	1	0	2	BB	PRT	Direct	Direct	C	C	3	No Deposit	NULL	NULL	Transient	0.0	0	Check-Out	2015-07-01
1	0	737	2015	July	27	1	0	2	BB	PRT	Direct	Direct	C	C	4	No Deposit	NULL	NULL	Transient	0.0	0	Check-Out	2015-07-01
2	0	7	2015	July	27	1	1	1	BB	GBR	Direct	Direct	A	C	0	No Deposit	NULL	NULL	Transient	75.0	0	Check-Out	2015-07-02
3	0	13	2015	July	27	1	1	1	BB	GBR	Corporate	Corporate	A	A	0	No Deposit	304	NULL	Transient	75.0	0	Check-Out	2015-07-02
4	0	14	2015	July	27	1	2	2	BB	GBR	Online TA	TA/TO	A	A	0	No Deposit	240	NULL	Transient	98.0	1	Check-Out	2015-07-03
5	0	14	2015	July	27	1	2	2	BB	GBR	Online TA	TA/TO	A	A	0	No Deposit	240	NULL	Transient	98.0	1	Check-Out	2015-07-03
6	0	0	2015	July	27	1	2	2	BB	PRT	Direct	Direct	C	C	0	No Deposit	NULL	NULL	Transient	107.0	0	Check-Out	2015-07-03
7	0	9	2015	July	27	1	2	2	FB	PRT	Direct	Direct	C	C	0	No Deposit	303	NULL	Transient	103.0	1	Check-Out	2015-07-03
8	1	85	2015	July	27	1	3	2	BB	PRT	Online TA	TA/TO	A	A	0	No Deposit	240	NULL	Transient	82.0	1	Canceled	2015-05-06
9	1	75	2015	July	27	1	3	2	HB	PRT	Offline TA/TO	TA/TO	D	D	0	No Deposit	15	NULL	Transient	105.5	0	Canceled	2015-04-22

	LeadTime	ArrivalDateYear	ArrivalDateMonth	ArrivalDateWeekNumber	ArrivalDateDayOfMonth	StaysInWeekendNights	StaysInWeekNights	Adults	Children	Meal	Country	MarketSegment	DistributionChannel	ReservedRoomType	AssignedRoomType	BookingChanges	DepositType	Agent	Company	CustomerType	ADR	TotalOfSpecialRequests	ReservationStatus	ReservationStatusDate
40050	173	2017	August	35	27	4	9	2	0	HB	PRT	Offline TA/TO	TA/TO	D	D	1	No Deposit	181	NULL	Transient-Party	168.92	1	Check-Out	2017-09-09
40051	264	2017	August	34	26	4	10	2	0	BB	NLD	Offline TA/TO	TA/TO	D	D	2	No Deposit	71	NULL	Transient	89.79	0	Check-Out	2017-09-09
40052	207	2017	August	34	26	4	10	2	0	HB	GBR	Offline TA/TO	TA/TO	E	E	0	No Deposit	143	NULL	Transient	131.70	2	Check-Out	2017-09-09
40053	269	2017	August	34	24	4	13	2	0	BB	GBR	Offline TA/TO	TA/TO	D	D	0	No Deposit	40	NULL	Contract	84.80	2	Check-Out	2017-09-10
40054	169	2017	August	35	30	2	9	2	0	BB	IRL	Direct	Direct	E	E	0	No Deposit	250	NULL	Transient-Party	204.27	1	Check-Out	2017-09-10
40055	212	2017	August	35	31	2	8	2	1	BB	GBR	Offline TA/TO	TA/TO	A	A	1	No Deposit	143	NULL	Transient	89.75	0	Check-Out	2017-09-10
40056	169	2017	August	35	30	2	9	2	0	BB	IRL	Direct	Direct	E	E	0	No Deposit	250	NULL	Transient-Party	202.27	1	Check-Out	2017-09-10
40057	204	2017	August	35	29	4	10	2	0	BB	IRL	Direct	Direct	E	E	0	No Deposit	250	NULL	Transient	153.57	3	Check-Out	2017-09-12
40058	211	2017	August	35	31	4	10	2	0	HB	GBR	Offline TA/TO	TA/TO	D	D	0	No Deposit	40	NULL	Contract	112.80	1	Check-Out	2017-09-14
40059	161	2017	August	35	31	4	10	2	0	HB	DEU	Offline TA/TO	TA/TO	A	A	0	No Deposit	69	NULL	Transient	99.06	0	Check-Out	2017-09-14

Most frequently occurring

	IsCanceled	LeadTime	ArrivalDateYear	ArrivalDateMonth	ArrivalDateWeekNumber	ArrivalDateDayOfMonth	StaysInWeekendNights	StaysInWeekNights	Adults	Meal	Country	MarketSegment	DistributionChannel	PreviousCancellations	ReservedRoomType	AssignedRoomType	DepositType	Agent	Company	CustomerType	ADR	ReservationStatus	ReservationStatusDate	# duplicates
1821	1	92	2016	February	9	26	1	2	2	Undefined	PRT	Groups	TA/TO	1	A	A	Non Refund	134	NULL	Transient	79.00	Canceled	2015-12-10	55
2221	1	259	2015	September	38	17	0	3	2	BB	GBR	Groups	Corporate	1	A	A	Non Refund	NULL	223	Transient	40.05	Canceled	2015-01-21	50
1853	1	106	2016	March	13	24	1	3	2	FB	PRT	Groups	Direct	0	A	A	Non Refund	68	NULL	Transient	84.00	Canceled	2016-01-22	40
2220	1	259	2015	September	38	17	0	3	1	BB	GBR	Groups	Corporate	1	A	A	Non Refund	NULL	223	Transient	33.30	Canceled	2015-01-21	40
604	0	40	2017	January	3	16	1	2	1	Undefined	PRT	Groups	Direct	0	A	A	No Deposit	NULL	NULL	Transient-Party	55.00	Check-Out	2017-01-19	29
1765	1	74	2016	February	9	26	1	2	2	Undefined	PRT	Groups	TA/TO	0	A	A	Non Refund	68	NULL	Transient	70.00	Canceled	2016-01-21	29
1951	1	140	2016	February	7	12	0	2	2	HB	PRT	Groups	TA/TO	0	A	A	Non Refund	NULL	NULL	Transient	50.00	Canceled	2015-12-11	29
1775	1	78	2015	October	41	9	1	2	2	FB	ESP	Groups	TA/TO	0	A	A	Non Refund	134	NULL	Transient	92.00	Canceled	2015-08-14	28
2252	1	277	2016	June	25	12	2	2	2	Undefined	PRT	Groups	TA/TO	0	A	A	Non Refund	NULL	NULL	Transient	110.00	Canceled	2016-03-29	28
2317	1	393	2016	October	41	8	2	2	2	HB	PRT	Groups	TA/TO	0	A	A	Non Refund	68	NULL	Transient	72.00	Canceled	2015-12-17	28

Overview

Variables

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Most occurring scripts

Most frequent character per script

Latin

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Uppercase Letter

Lowercase Letter

Space Separator

Most occurring scripts

Most frequent character per script

Latin

Common